﻿CREATE TABLE spm.SsasServer -- we add olap before 'server' because server is a sql server reserved word
(
	/*
	 * Table to support the SSAS Partition Manager.  See https://SSASPartitionManager.codeplex.com/documentation for documentation.
     *
	 * Part of the SSAS Partition Manager sample code which can be downloaded from https://SSASPartitionManager.codeplex.com/
	 * 
	 * Written by Dr. John Tunnicliffe, independent business intelligence consultant
	 * Available for consultancy assignments and speaking engagements
     * 	
	 * eMail: john@decision-analytics.co.uk 
	 * http://www.decision-analytics.co.uk/
	 * http://www.sqlbits.com/Speakers/Dr_John_Tunnicliffe
	 * https://www.linkedin.com/in/drjohntunnicliffe
	 */ 
	SsasServerKey INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	SsasServerType nvarchar(10) NOT NULL UNIQUE,	-- e.g. DEV_OLAP, DEV_TABULAR, UAT_OLAP, PROD_OLAP etc.
	SsasServerName nvarchar(200) NOT NULL,			-- include the port and instance name if required
);
GO

